﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ATRASOSDataSet" targetNamespace="http://tempuri.org/ATRASOSDataSet.xsd" xmlns:mstns="http://tempuri.org/ATRASOSDataSet.xsd" xmlns="http://tempuri.org/ATRASOSDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="GBDConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GBDConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.GERENCIAMENTO___VITORIA.My.MySettings.GlobalReference.Default.GBDConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ONLINEConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ONLINEConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.GERENCIAMENTO___VITORIA.My.MySettings.GlobalReference.Default.ONLINEConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ATRASOSTableAdapter" GeneratorDataComponentClassName="ATRASOSTableAdapter" Name="ATRASOS" UserDataComponentName="ATRASOSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ONLINEConnectionString (MySettings)" DbObjectName="gerenciamento.dbo.ATRASOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ATRASOS] WHERE (([ID] = @Original_ID) AND ((@IsNull_CEDENTE = 1 AND [CEDENTE] IS NULL) OR ([CEDENTE] = @Original_CEDENTE)) AND ((@IsNull_SACADO = 1 AND [SACADO] IS NULL) OR ([SACADO] = @Original_SACADO)) AND ((@IsNull_TIPO = 1 AND [TIPO] IS NULL) OR ([TIPO] = @Original_TIPO)) AND ((@IsNull_ALINEA = 1 AND [ALINEA] IS NULL) OR ([ALINEA] = @Original_ALINEA)) AND ((@IsNull_BORDERO = 1 AND [BORDERO] IS NULL) OR ([BORDERO] = @Original_BORDERO)) AND ((@IsNull_NUMERO = 1 AND [NUMERO] IS NULL) OR ([NUMERO] = @Original_NUMERO)) AND ((@IsNull_VALOR = 1 AND [VALOR] IS NULL) OR ([VALOR] = @Original_VALOR)) AND ((@IsNull_VENCIMENTO = 1 AND [VENCIMENTO] IS NULL) OR ([VENCIMENTO] = @Original_VENCIMENTO)) AND ((@IsNull_CONTA = 1 AND [CONTA] IS NULL) OR ([CONTA] = @Original_CONTA)) AND ((@IsNull_REAPRESENTADO = 1 AND [REAPRESENTADO] IS NULL) OR ([REAPRESENTADO] = @Original_REAPRESENTADO)) AND ((@IsNull_DATAREP = 1 AND [DATAREP] IS NULL) OR ([DATAREP] = @Original_DATAREP)) AND ((@IsNull_DATAINCLU = 1 AND [DATAINCLU] IS NULL) OR ([DATAINCLU] = @Original_DATAINCLU)) AND ((@IsNull_TIPOPEN = 1 AND [TIPOPEN] IS NULL) OR ([TIPOPEN] = @Original_TIPOPEN)) AND ((@IsNull_OBS = 1 AND [OBS] IS NULL) OR ([OBS] = @Original_OBS)) AND ((@IsNull_NAEMPRESA = 1 AND [NAEMPRESA] IS NULL) OR ([NAEMPRESA] = @Original_NAEMPRESA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CEDENTE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CEDENTE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CEDENTE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CEDENTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SACADO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SACADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SACADO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SACADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TIPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TIPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TIPO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TIPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALINEA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALINEA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALINEA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALINEA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BORDERO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BORDERO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BORDERO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BORDERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NUMERO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMERO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NUMERO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VALOR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VALOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_VALOR" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="VALOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VENCIMENTO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VENCIMENTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_VENCIMENTO" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="VENCIMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CONTA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CONTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CONTA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CONTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REAPRESENTADO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REAPRESENTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_REAPRESENTADO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="REAPRESENTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATAREP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATAREP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DATAREP" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATAREP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATAINCLU" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATAINCLU" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DATAINCLU" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATAINCLU" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TIPOPEN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TIPOPEN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TIPOPEN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TIPOPEN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OBS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OBS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_OBS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OBS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NAEMPRESA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NAEMPRESA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NAEMPRESA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NAEMPRESA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ATRASOS] ([CEDENTE], [SACADO], [TIPO], [ALINEA], [BORDERO], [NUMERO], [VALOR], [VENCIMENTO], [CONTA], [REAPRESENTADO], [DATAREP], [DATAINCLU], [TIPOPEN], [OBS], [NAEMPRESA]) VALUES (@CEDENTE, @SACADO, @TIPO, @ALINEA, @BORDERO, @NUMERO, @VALOR, @VENCIMENTO, @CONTA, @REAPRESENTADO, @DATAREP, @DATAINCLU, @TIPOPEN, @OBS, @NAEMPRESA);
SELECT ID, CEDENTE, SACADO, TIPO, ALINEA, BORDERO, NUMERO, VALOR, VENCIMENTO, CONTA, REAPRESENTADO, DATAREP, DATAINCLU, TIPOPEN, OBS, NAEMPRESA FROM ATRASOS WHERE (ID = SCOPE_IDENTITY()) ORDER BY CEDENTE</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CEDENTE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CEDENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SACADO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SACADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TIPO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TIPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALINEA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BORDERO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BORDERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NUMERO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@VALOR" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="VALOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@VENCIMENTO" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="VENCIMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CONTA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CONTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@REAPRESENTADO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="REAPRESENTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DATAREP" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATAREP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DATAINCLU" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATAINCLU" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TIPOPEN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TIPOPEN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OBS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OBS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NAEMPRESA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NAEMPRESA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, CEDENTE, SACADO, TIPO, ALINEA, BORDERO, NUMERO, VALOR, VENCIMENTO, CONTA, REAPRESENTADO, DATAREP, DATAINCLU, TIPOPEN, OBS, NAEMPRESA FROM dbo.ATRASOS
ORDER BY CEDENTE</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ATRASOS] SET [CEDENTE] = @CEDENTE, [SACADO] = @SACADO, [TIPO] = @TIPO, [ALINEA] = @ALINEA, [BORDERO] = @BORDERO, [NUMERO] = @NUMERO, [VALOR] = @VALOR, [VENCIMENTO] = @VENCIMENTO, [CONTA] = @CONTA, [REAPRESENTADO] = @REAPRESENTADO, [DATAREP] = @DATAREP, [DATAINCLU] = @DATAINCLU, [TIPOPEN] = @TIPOPEN, [OBS] = @OBS, [NAEMPRESA] = @NAEMPRESA WHERE (([ID] = @Original_ID) AND ((@IsNull_CEDENTE = 1 AND [CEDENTE] IS NULL) OR ([CEDENTE] = @Original_CEDENTE)) AND ((@IsNull_SACADO = 1 AND [SACADO] IS NULL) OR ([SACADO] = @Original_SACADO)) AND ((@IsNull_TIPO = 1 AND [TIPO] IS NULL) OR ([TIPO] = @Original_TIPO)) AND ((@IsNull_ALINEA = 1 AND [ALINEA] IS NULL) OR ([ALINEA] = @Original_ALINEA)) AND ((@IsNull_BORDERO = 1 AND [BORDERO] IS NULL) OR ([BORDERO] = @Original_BORDERO)) AND ((@IsNull_NUMERO = 1 AND [NUMERO] IS NULL) OR ([NUMERO] = @Original_NUMERO)) AND ((@IsNull_VALOR = 1 AND [VALOR] IS NULL) OR ([VALOR] = @Original_VALOR)) AND ((@IsNull_VENCIMENTO = 1 AND [VENCIMENTO] IS NULL) OR ([VENCIMENTO] = @Original_VENCIMENTO)) AND ((@IsNull_CONTA = 1 AND [CONTA] IS NULL) OR ([CONTA] = @Original_CONTA)) AND ((@IsNull_REAPRESENTADO = 1 AND [REAPRESENTADO] IS NULL) OR ([REAPRESENTADO] = @Original_REAPRESENTADO)) AND ((@IsNull_DATAREP = 1 AND [DATAREP] IS NULL) OR ([DATAREP] = @Original_DATAREP)) AND ((@IsNull_DATAINCLU = 1 AND [DATAINCLU] IS NULL) OR ([DATAINCLU] = @Original_DATAINCLU)) AND ((@IsNull_TIPOPEN = 1 AND [TIPOPEN] IS NULL) OR ([TIPOPEN] = @Original_TIPOPEN)) AND ((@IsNull_OBS = 1 AND [OBS] IS NULL) OR ([OBS] = @Original_OBS)) AND ((@IsNull_NAEMPRESA = 1 AND [NAEMPRESA] IS NULL) OR ([NAEMPRESA] = @Original_NAEMPRESA)));
SELECT ID, CEDENTE, SACADO, TIPO, ALINEA, BORDERO, NUMERO, VALOR, VENCIMENTO, CONTA, REAPRESENTADO, DATAREP, DATAINCLU, TIPOPEN, OBS, NAEMPRESA FROM ATRASOS WHERE (ID = @ID) ORDER BY CEDENTE</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CEDENTE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CEDENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SACADO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SACADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TIPO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TIPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALINEA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BORDERO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BORDERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NUMERO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@VALOR" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="VALOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@VENCIMENTO" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="VENCIMENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CONTA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CONTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@REAPRESENTADO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="REAPRESENTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DATAREP" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATAREP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DATAINCLU" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATAINCLU" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TIPOPEN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TIPOPEN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OBS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OBS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NAEMPRESA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NAEMPRESA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CEDENTE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CEDENTE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CEDENTE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CEDENTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SACADO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SACADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SACADO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SACADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TIPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TIPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TIPO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TIPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALINEA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALINEA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALINEA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALINEA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BORDERO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BORDERO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BORDERO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BORDERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NUMERO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMERO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NUMERO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NUMERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VALOR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VALOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_VALOR" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="VALOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VENCIMENTO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VENCIMENTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_VENCIMENTO" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="VENCIMENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CONTA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CONTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CONTA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CONTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REAPRESENTADO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REAPRESENTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_REAPRESENTADO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="REAPRESENTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATAREP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATAREP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DATAREP" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATAREP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATAINCLU" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATAINCLU" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DATAINCLU" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATAINCLU" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TIPOPEN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TIPOPEN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TIPOPEN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TIPOPEN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OBS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OBS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_OBS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OBS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NAEMPRESA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NAEMPRESA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NAEMPRESA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NAEMPRESA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="CEDENTE" DataSetColumn="CEDENTE" />
              <Mapping SourceColumn="SACADO" DataSetColumn="SACADO" />
              <Mapping SourceColumn="TIPO" DataSetColumn="TIPO" />
              <Mapping SourceColumn="ALINEA" DataSetColumn="ALINEA" />
              <Mapping SourceColumn="BORDERO" DataSetColumn="BORDERO" />
              <Mapping SourceColumn="NUMERO" DataSetColumn="NUMERO" />
              <Mapping SourceColumn="VALOR" DataSetColumn="VALOR" />
              <Mapping SourceColumn="VENCIMENTO" DataSetColumn="VENCIMENTO" />
              <Mapping SourceColumn="CONTA" DataSetColumn="CONTA" />
              <Mapping SourceColumn="REAPRESENTADO" DataSetColumn="REAPRESENTADO" />
              <Mapping SourceColumn="DATAREP" DataSetColumn="DATAREP" />
              <Mapping SourceColumn="DATAINCLU" DataSetColumn="DATAINCLU" />
              <Mapping SourceColumn="TIPOPEN" DataSetColumn="TIPOPEN" />
              <Mapping SourceColumn="OBS" DataSetColumn="OBS" />
              <Mapping SourceColumn="NAEMPRESA" DataSetColumn="NAEMPRESA" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="GBDConnectionString (MySettings)" DbObjectName="gerenciamento.dbo.ATRASOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByALINEA" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillByALINEA" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByALINEA">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ALINEA, BORDERO, CEDENTE, CONTA, DATAINCLU, DATAREP, ID, NAEMPRESA, NUMERO, OBS, REAPRESENTADO, SACADO, TIPO, TIPOPEN, VALOR, VENCIMENTO FROM ATRASOS WHERE (ALINEA = @ALINEA) ORDER BY CEDENTE, SACADO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ALINEA" ColumnName="ALINEA" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@ALINEA" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="ALINEA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GBDConnectionString (MySettings)" DbObjectName="gerenciamento.dbo.ATRASOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCEDENTE" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="FillByCEDENTE" GetMethodModifier="Public" GetMethodName="GetDataBy1" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillByCEDENTE">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ALINEA, BORDERO, CEDENTE, CONTA, DATAINCLU, DATAREP, ID, NAEMPRESA, NUMERO, OBS, REAPRESENTADO, SACADO, TIPO, TIPOPEN, VALOR, VENCIMENTO FROM ATRASOS WHERE (CEDENTE LIKE '%' + @CEDENTE + '%') ORDER BY CEDENTE, SACADO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CEDENTE" ColumnName="CEDENTE" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="nvarchar(300)" DbType="String" Direction="Input" ParameterName="@CEDENTE" Precision="0" ProviderType="NVarChar" Scale="0" Size="300" SourceColumn="CEDENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GBDConnectionString (MySettings)" DbObjectName="gerenciamento.dbo.ATRASOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCONTA" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy2" GeneratorSourceName="FillByCONTA" GetMethodModifier="Public" GetMethodName="GetDataBy2" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="FillByCONTA">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ALINEA, BORDERO, CEDENTE, CONTA, DATAINCLU, DATAREP, ID, NAEMPRESA, NUMERO, OBS, REAPRESENTADO, SACADO, TIPO, TIPOPEN, VALOR, VENCIMENTO FROM ATRASOS WHERE (CONTA = @CONTA) ORDER BY CEDENTE, SACADO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CONTA" ColumnName="CONTA" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="nvarchar(150)" DbType="String" Direction="Input" ParameterName="@CONTA" Precision="0" ProviderType="NVarChar" Scale="0" Size="150" SourceColumn="CONTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GBDConnectionString (MySettings)" DbObjectName="gerenciamento.dbo.ATRASOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDATAINCLU" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy3" GeneratorSourceName="FillByDATAINCLU" GetMethodModifier="Public" GetMethodName="GetDataBy3" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="FillByDATAINCLU">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ALINEA, BORDERO, CEDENTE, CONTA, DATAINCLU, DATAREP, ID, NAEMPRESA, NUMERO, OBS, REAPRESENTADO, SACADO, TIPO, TIPOPEN, VALOR, VENCIMENTO FROM ATRASOS WHERE (DATAINCLU = @DATAINCLU) ORDER BY CEDENTE, SACADO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="DATAINCLU" ColumnName="DATAINCLU" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DATAINCLU" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="DATAINCLU" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GBDConnectionString (MySettings)" DbObjectName="gerenciamento.dbo.ATRASOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDATAREP" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy4" GeneratorSourceName="FillByDATAREP" GetMethodModifier="Public" GetMethodName="GetDataBy4" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="FillByDATAREP">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ALINEA, BORDERO, CEDENTE, CONTA, DATAINCLU, DATAREP, ID, NAEMPRESA, NUMERO, OBS, REAPRESENTADO, SACADO, TIPO, TIPOPEN, VALOR, VENCIMENTO FROM ATRASOS WHERE (DATAREP = @DATAREP) ORDER BY CEDENTE, SACADO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="DATAREP" ColumnName="DATAREP" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DATAREP" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="DATAREP" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ONLINEConnectionString (MySettings)" DbObjectName="gerenciamento.dbo.ATRASOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFALTANDO" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy11" GeneratorSourceName="FillByFALTANDO" GetMethodModifier="Public" GetMethodName="GetDataBy11" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy11" UserSourceName="FillByFALTANDO">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, CEDENTE, SACADO, TIPO, ALINEA, BORDERO, NUMERO, VALOR, VENCIMENTO, CONTA, REAPRESENTADO, DATAREP, DATAINCLU, TIPOPEN, OBS, NAEMPRESA FROM dbo.ATRASOS
WHERE CEDENTE = @CEDENTE AND NAEMPRESA = @NAEMPRESA AND CONTA =@CONTA AND REAPRESENTADO = @REP
ORDER BY CEDENTE,SACADO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CEDENTE" ColumnName="CEDENTE" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="nvarchar(300)" DbType="String" Direction="Input" ParameterName="@CEDENTE" Precision="0" ProviderType="NVarChar" Scale="0" Size="300" SourceColumn="CEDENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="NAEMPRESA" ColumnName="NAEMPRESA" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@NAEMPRESA" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="NAEMPRESA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CONTA" ColumnName="CONTA" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="nvarchar(150)" DbType="String" Direction="Input" ParameterName="@CONTA" Precision="0" ProviderType="NVarChar" Scale="0" Size="150" SourceColumn="CONTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="REP" ColumnName="REAPRESENTADO" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@REP" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="REAPRESENTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GBDConnectionString (MySettings)" DbObjectName="gerenciamento.dbo.ATRASOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFICHINHA" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy5" GeneratorSourceName="FillByFICHINHA" GetMethodModifier="Public" GetMethodName="GetDataBy5" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="FillByFICHINHA">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ALINEA, BORDERO, CEDENTE, CONTA, DATAINCLU, DATAREP, ID, NAEMPRESA, NUMERO, OBS, REAPRESENTADO, SACADO, TIPO, TIPOPEN, VALOR, VENCIMENTO FROM ATRASOS WHERE (DATAREP = @DATAREP) AND (REAPRESENTADO = 'SIM') ORDER BY CONTA, CEDENTE, SACADO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="DATAREP" ColumnName="DATAREP" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DATAREP" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="DATAREP" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GBDConnectionString (MySettings)" DbObjectName="gerenciamento.dbo.ATRASOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByNAEMPRESA" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy6" GeneratorSourceName="FillByNAEMPRESA" GetMethodModifier="Public" GetMethodName="GetDataBy6" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="FillByNAEMPRESA">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ALINEA, BORDERO, CEDENTE, CONTA, DATAINCLU, DATAREP, ID, NAEMPRESA, NUMERO, OBS, REAPRESENTADO, SACADO, TIPO, TIPOPEN, VALOR, VENCIMENTO FROM ATRASOS WHERE (NAEMPRESA = @NAEMPRESA) ORDER BY CEDENTE, SACADO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="NAEMPRESA" ColumnName="NAEMPRESA" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@NAEMPRESA" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="NAEMPRESA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GBDConnectionString (MySettings)" DbObjectName="gerenciamento.dbo.ATRASOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySACADO" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy7" GeneratorSourceName="FillBySACADO" GetMethodModifier="Public" GetMethodName="GetDataBy7" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy7" UserSourceName="FillBySACADO">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ALINEA, BORDERO, CEDENTE, CONTA, DATAINCLU, DATAREP, ID, NAEMPRESA, NUMERO, OBS, REAPRESENTADO, SACADO, TIPO, TIPOPEN, VALOR, VENCIMENTO FROM ATRASOS WHERE (SACADO LIKE '%' + @SACADO + '%') ORDER BY CEDENTE, SACADO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="SACADO" ColumnName="SACADO" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="nvarchar(300)" DbType="String" Direction="Input" ParameterName="@SACADO" Precision="0" ProviderType="NVarChar" Scale="0" Size="300" SourceColumn="SACADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GBDConnectionString (MySettings)" DbObjectName="gerenciamento.dbo.ATRASOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTIPO" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy8" GeneratorSourceName="FillByTIPO" GetMethodModifier="Public" GetMethodName="GetDataBy8" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy8" UserSourceName="FillByTIPO">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ALINEA, BORDERO, CEDENTE, CONTA, DATAINCLU, DATAREP, ID, NAEMPRESA, NUMERO, OBS, REAPRESENTADO, SACADO, TIPO, TIPOPEN, VALOR, VENCIMENTO FROM ATRASOS WHERE (TIPO = @TIPO) ORDER BY CEDENTE, SACADO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="TIPO" ColumnName="TIPO" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@TIPO" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="TIPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GBDConnectionString (MySettings)" DbObjectName="gerenciamento.dbo.ATRASOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTIPOPEN" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy9" GeneratorSourceName="FillByTIPOPEN" GetMethodModifier="Public" GetMethodName="GetDataBy9" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy9" UserSourceName="FillByTIPOPEN">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ALINEA, BORDERO, CEDENTE, CONTA, DATAINCLU, DATAREP, ID, NAEMPRESA, NUMERO, OBS, REAPRESENTADO, SACADO, TIPO, TIPOPEN, VALOR, VENCIMENTO FROM ATRASOS WHERE (TIPOPEN = @TIPOPEN) ORDER BY CEDENTE, SACADO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="TIPOPEN" ColumnName="TIPOPEN" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="nvarchar(150)" DbType="String" Direction="Input" ParameterName="@TIPOPEN" Precision="0" ProviderType="NVarChar" Scale="0" Size="150" SourceColumn="TIPOPEN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GBDConnectionString (MySettings)" DbObjectName="gerenciamento.dbo.ATRASOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByVALOR" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy10" GeneratorSourceName="FillByVALOR" GetMethodModifier="Public" GetMethodName="GetDataBy10" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy10" UserSourceName="FillByVALOR">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ALINEA, BORDERO, CEDENTE, CONTA, DATAINCLU, DATAREP, ID, NAEMPRESA, NUMERO, OBS, REAPRESENTADO, SACADO, TIPO, TIPOPEN, VALOR, VENCIMENTO FROM ATRASOS WHERE (VALOR = @VALOR) ORDER BY CEDENTE, SACADO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="VALOR" ColumnName="VALOR" DataSourceName="gerenciamento.dbo.ATRASOS" DataTypeServer="money" DbType="Currency" Direction="Input" ParameterName="@VALOR" Precision="0" ProviderType="Money" Scale="0" Size="8" SourceColumn="VALOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ATRASOSDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ATRASOSDataSet" msprop:Generator_UserDSName="ATRASOSDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ATRASOS" msprop:Generator_TableClassName="ATRASOSDataTable" msprop:Generator_TableVarName="tableATRASOS" msprop:Generator_TablePropName="ATRASOS" msprop:Generator_RowDeletingName="ATRASOSRowDeleting" msprop:Generator_UserTableName="ATRASOS" msprop:Generator_RowChangingName="ATRASOSRowChanging" msprop:Generator_RowEvHandlerName="ATRASOSRowChangeEventHandler" msprop:Generator_RowDeletedName="ATRASOSRowDeleted" msprop:Generator_RowEvArgName="ATRASOSRowChangeEvent" msprop:Generator_RowChangedName="ATRASOSRowChanged" msprop:Generator_RowClassName="ATRASOSRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="CEDENTE" msprop:Generator_ColumnVarNameInTable="columnCEDENTE" msprop:Generator_ColumnPropNameInRow="CEDENTE" msprop:Generator_ColumnPropNameInTable="CEDENTEColumn" msprop:Generator_UserColumnName="CEDENTE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SACADO" msprop:Generator_ColumnVarNameInTable="columnSACADO" msprop:Generator_ColumnPropNameInRow="SACADO" msprop:Generator_ColumnPropNameInTable="SACADOColumn" msprop:Generator_UserColumnName="SACADO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TIPO" msprop:Generator_ColumnVarNameInTable="columnTIPO" msprop:Generator_ColumnPropNameInRow="TIPO" msprop:Generator_ColumnPropNameInTable="TIPOColumn" msprop:Generator_UserColumnName="TIPO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ALINEA" msprop:Generator_ColumnVarNameInTable="columnALINEA" msprop:Generator_ColumnPropNameInRow="ALINEA" msprop:Generator_ColumnPropNameInTable="ALINEAColumn" msprop:Generator_UserColumnName="ALINEA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BORDERO" msprop:Generator_ColumnVarNameInTable="columnBORDERO" msprop:Generator_ColumnPropNameInRow="BORDERO" msprop:Generator_ColumnPropNameInTable="BORDEROColumn" msprop:Generator_UserColumnName="BORDERO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMERO" msprop:Generator_ColumnVarNameInTable="columnNUMERO" msprop:Generator_ColumnPropNameInRow="NUMERO" msprop:Generator_ColumnPropNameInTable="NUMEROColumn" msprop:Generator_UserColumnName="NUMERO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VALOR" msprop:Generator_ColumnVarNameInTable="columnVALOR" msprop:Generator_ColumnPropNameInRow="VALOR" msprop:Generator_ColumnPropNameInTable="VALORColumn" msprop:Generator_UserColumnName="VALOR" type="xs:decimal" minOccurs="0" />
              <xs:element name="VENCIMENTO" msprop:Generator_ColumnVarNameInTable="columnVENCIMENTO" msprop:Generator_ColumnPropNameInRow="VENCIMENTO" msprop:Generator_ColumnPropNameInTable="VENCIMENTOColumn" msprop:Generator_UserColumnName="VENCIMENTO" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CONTA" msprop:Generator_ColumnVarNameInTable="columnCONTA" msprop:Generator_ColumnPropNameInRow="CONTA" msprop:Generator_ColumnPropNameInTable="CONTAColumn" msprop:Generator_UserColumnName="CONTA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="REAPRESENTADO" msprop:Generator_ColumnVarNameInTable="columnREAPRESENTADO" msprop:Generator_ColumnPropNameInRow="REAPRESENTADO" msprop:Generator_ColumnPropNameInTable="REAPRESENTADOColumn" msprop:Generator_UserColumnName="REAPRESENTADO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DATAREP" msprop:Generator_ColumnVarNameInTable="columnDATAREP" msprop:Generator_ColumnPropNameInRow="DATAREP" msprop:Generator_ColumnPropNameInTable="DATAREPColumn" msprop:Generator_UserColumnName="DATAREP" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DATAINCLU" msprop:Generator_ColumnVarNameInTable="columnDATAINCLU" msprop:Generator_ColumnPropNameInRow="DATAINCLU" msprop:Generator_ColumnPropNameInTable="DATAINCLUColumn" msprop:Generator_UserColumnName="DATAINCLU" type="xs:dateTime" minOccurs="0" />
              <xs:element name="TIPOPEN" msprop:Generator_ColumnVarNameInTable="columnTIPOPEN" msprop:Generator_ColumnPropNameInRow="TIPOPEN" msprop:Generator_ColumnPropNameInTable="TIPOPENColumn" msprop:Generator_UserColumnName="TIPOPEN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OBS" msprop:Generator_ColumnVarNameInTable="columnOBS" msprop:Generator_ColumnPropNameInRow="OBS" msprop:Generator_ColumnPropNameInTable="OBSColumn" msprop:Generator_UserColumnName="OBS" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NAEMPRESA" msprop:Generator_ColumnVarNameInTable="columnNAEMPRESA" msprop:Generator_ColumnPropNameInRow="NAEMPRESA" msprop:Generator_ColumnPropNameInTable="NAEMPRESAColumn" msprop:Generator_UserColumnName="NAEMPRESA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ATRASOS" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>